Opening a file in visual c# not a valid filename

[johnlarson]

I am using an openfiledialoge to open a dbf file in a windows app. the error I get is c:\myfile.dbf not an valid filename. here is my code

private void button1_Click ( object sender , EventArgs e )
            {
            System.Windows.Forms.DataGrid ZipCode=null; 
            System . IO . Stream myStream = null;
            OpenFileDialog openFileDialog1 = new OpenFileDialog ( );
            openFileDialog1 . InitialDirectory = "c:\\";
            openFileDialog1 . Filter = "dbf files (*.dbf)|*.dbf";
            openFileDialog1 . FilterIndex = 0;
            openFileDialog1 . RestoreDirectory = true;
            openFileDialog1 . CheckFileExists = true;
            openFileDialog1 . CheckPathExists = true;
            if ( openFileDialog1 . ShowDialog ( ) == DialogResult . OK )
                {
                try
                    {
                    if ( ( myStream = openFileDialog1 . OpenFile ( ) ) != null )
                        {//if
                        using ( myStream )
                            {//using
                        string fullPathname = openFileDialog1 . FileName;
                        string connectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\\;Extended Properties=dBASE IV;User ID=Admin;Password=";
                        string commandString = "Select * from '" + fullPathname + "'";
                        OleDbDataAdapter DataAdapter = new OleDbDataAdapter (commandString,connectionString );
                        DataSet DataSet = new DataSet ( );
                        DataAdapter . Fill ( DataSet , fullPathname );
              ZipCode.DataSource = DataSet . Tables [ fullPathname ] . DefaultView;
                            } //end using
                        } //end if                    
                 }catch( Exception ex )
                    {
                    MessageBox . Show ( "  error: " + ex . Message );
                    }
                }
            }
 

[balabaster]

I am using an openfiledialoge to open a dbf file in a windows app. the error I get is c:\myfile.dbf not an valid filename. here is my code
<code>
private void button1_Click ( object sender , EventArgs e )
{
System.Windows.Forms.DataGrid ZipCode=null;
System . IO . Stream myStream = null;
OpenFileDialog openFileDialog1 = new OpenFileDialog ( );
openFileDialog1 . InitialDirectory = "c:\\";
openFileDialog1 . Filter = "dbf files (*.dbf)|*.dbf";
openFileDialog1 . FilterIndex = 0;
openFileDialog1 . RestoreDirectory = true;
openFileDialog1 . CheckFileExists = true;
openFileDialog1 . CheckPathExists = true;
if ( openFileDialog1 . ShowDialog ( ) == DialogResult . OK )
{
try
{
if ( ( myStream = openFileDialog1 . OpenFile ( ) ) != null )
{//if
using ( myStream )
{//using
string fullPathname = openFileDialog1 . FileName;
string connectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\\;Extended Properties=dBASE IV;User ID=Admin;Password=";
string commandString = "Select * from '" + fullPathname + "'";
OleDbDataAdapter DataAdapter = new OleDbDataAdapter (commandString,connectionString );
DataSet DataSet = new DataSet ( );
DataAdapter . Fill ( DataSet , fullPathname );
ZipCode.DataSource = DataSet . Tables [ fullPathname ] . DefaultView;
} //end using
} //end if
}catch( Exception ex )
{
MessageBox . Show ( " error: " + ex . Message );
}
}
}
</code>

Well my first thought is that the file doesn't exist...

[johnlarson]

Well my first thought is that the file doesn't exist...

the fille exists it is a .dbf file from the usps. I have been debugging and the line that triggers the exception is

ZipCode.DataSource = DataSet . Tables [ fullPathname ] . DefaultView;

when I put a watch on the line it says the DataSet.Tables[fullPathname] is null
thanks for your time
John Larson

[balabaster]

the fille exists it is a .dbf file from the usps. I have been debugging and the line that triggers the exception is

ZipCode.DataSource = DataSet . Tables [ fullPathname ] . DefaultView;

when I put a watch on the line it says the DataSet.Tables[fullPathname] is null
thanks for your time
John Larson

Does your database have a table in it with the same name as your DBF? I've gotta say I'm clueless on DBase so I'm running blind - I only have MS Access and SQL Server and my example works...
VB

Dim fileName As String = "C:\MyDB.accdb" 
Dim tableName As String = "MyTable"
Dim sConStr As String = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" & fileName & ";Persist Security Info=False;"
Dim oDA As New OleDbDataAdapter("Select * From " & tableName, sConStr)
Dim oDS As New DataSet("MyDataSet")
oDA.Fill(oDS, "MyTable")
ListBox1.DataSource = oDS.Tables("MyTable")
 

C#

string fileName = "C:\\MyDB.accdb"; 
string tableName = "MyTable";
string sConStr = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + fileName + ";Persist Security Info=False;
OleDbDataAdapter oDA = New OleDbDataAdapter("Select * From " + tableName, sConStr);
DataSet oDS = New DataSet("MyDataSet");
oDA.Fill(oDS, "MyTable");
ListBox1.DataSource = oDS.Tables["MyTable"];
 

So given what you've said, I'm curious if the structure of your database is as you expect...or that you've overlooked something in that area.

[johnlarson]

I am using the same file path as you are and my application cannot find the file. I have changed a lot of code this is what I am trying to make work

try
         {
         string conString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\\ZIP.DBF;Extended Properties=dBase IV";
         OleDbConnection conn = new OleDbConnection ( conString );
         command = conn . CreateCommand ( );
 
         // create the DataSet
         DataSet ds = new DataSet ( );
         dataGridView1 . DataSource = null;
 
         // open the connection
         conn . Open ( );
         string commandString = "Select * from  ZIP.DBF";
         // run the query
         command . CommandText = commandString;
         OleDbDataAdapter adapter = new OleDbDataAdapter ( command );
         adapter . Fill ( ds );
 
         // close the connection
         conn . Close ( );
 
         // set the grid's data source
         dataGridView1 . DataSource = ds . Tables [ 0 ];
         }
     catch ( Exception ex)
         {
         MessageBox . Show (  ex . Message );
 
         }             
 

I have also downloaded a shareware dbf viewer and it opens the file and correctly displays the file columns and rows
john larson
thanks for the time

[johnlarson]

I have cured this problem with this line

fullPath2 = Path . GetDirectoryName ( openFileDialog1 . FileName );

then I feed fullpath2 into my connection string and It worked. thanks for all of your help
John Larson

[Plater]

I have cured this problem with this line

fullPath2 = Path . GetDirectoryName ( openFileDialog1 . FileName );

then I feed fullpath2 into my connection string and It worked. thanks for all of your help
John Larson

I was going to say your connection string does not point to a database, just a path.